價格:免費
更新日期:2016-10-14
檔案大小:23.8 MB
目前版本:10.1.120
版本需求:需要 iOS 8.0 或以上版本。與 iPhone、iPad 及 iPod touch 相容。
支援語言:英語
SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language.
This tutorial will give you quick start with SQL.
include:SQL Tutorial、Advanced SQL、SQL Interview Questions、SQL Online Quiz、Useful Functions
1.SQL - Overview
2.SQL - RDBMS Concepts
3.SQL - RDBMS Databases
4.SQL - Syntax
5.SQL - Data Types
6.SQL - Operators
7.SQL - Expressions
8.SQL - CREATE Database
9.SQL - DROP or DELETE Database
10.SQL - SELECT Database, USE Statement
11.SQL - CREATE Table
12.SQL - DROP or DELETE Table
13.SQL - INSERT Query
14.SQL - SELECT Query
15.SQL - WHERE Clause
16.SQL - AND and OR Conjunctive Operators
17.SQL - UPDATE Query
18.SQL - DELETE Query
19.SQL - LIKE Clause
20.SQL - TOP, LIMIT or ROWNUM Clause
21.SQL - ORDER BY Clause
22.SQL - Group By
23.SQL - Distinct Keyword
24.SQL - SORTING Results
*****Advanced SQL
25.SQL - Constraints
26.SQL - Using Joins
27.SQL - UNIONS CLAUSE
28.SQL - NULL Values
29.SQL - Alias Syntax
30.SQL - Indexes
31.SQL - ALTER TABLE Command
32.SQL - TRUNCATE TABLE Command
33.SQL - Using Views
34.SQL - Having Clause
35.SQL - Transactions
36.SQL - Wildcard Operators
37.SQL - Date Functions
38.SQL - Temporary Tables
39.SQL - Clone Tables
40.SQL - Sub Queries
41.SQL - Using Sequences
42.SQL - Handling Duplicates
43.SQL - Injection
44.SQL COUNT Function
45.SQL MAX Function
46.SQL MIN Function
47.SQL AVG Function
48.SQL SUM Function
49.SQL SQRT Functions
50.SQL RAND Function
51.SQL CONCAT Function
52.SQL Numeric Functions
53.SQL String Functions
支援平台:iPhone, iPad